package cn.com.cifi.mars.mapper.mars;


import cn.com.cifi.mars.bean.dto.NosTradeDto;
import cn.com.cifi.mars.entity.*;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.time.LocalDateTime;
import java.util.List;
import java.util.Map;
import java.util.Set;


/**
 * <p>
 * 回款系数详情表 Mapper 接口
 * </p>
 *
 * @author JingYuanXiang
 * @since 2020-11-05
 */
public interface ReturnCoefficientDetailMapper extends BaseMapper<ReturnCoefficientDetail> {

    void updateByCoefficientId(@Param("versionId") String versionId,@Param("userName") String userName, @Param("isDel") int isDel);

    List<PanoplanBuildPlanItem> queryBySingIdList(@Param("singIdList")List<String> singIdList);

    List<PanoplanBuildPlanItemDetail> queryByPkIdList(@Param("pkIds")List<String> pkIds);

    List<ReturnCoefficientDetail> queryByCoefficientIds(@Param("id")String id,@Param("isDel") int isDel);

    SignPlanProgress selectByProjectId(@Param("projectId")String projectId, @Param("isDel") int isDel);

    List<String> queryStagesIdByProjectId(@Param("projectId")String projectId);

    Set<String> queryFetchNum(@Param("stagesIds")List<String> stagesIds);

    List<NosTradeDto> queryMymContractListForNos(@Param("projectId")String projectId);

    String selectCityOfProject(@Param("projectId") String projectId);

    List<DmCityReturnCoefficient> queryCityDetail(@Param("cityId") String cityId, @Param("time") LocalDateTime time);

	List<Map<String, Object>> queryProductCodeBySingIdList(@Param("singIdList")List<String> singIdList);

    List<ReturnCoefficientDetail> selectLastTimeGroupByProjectId(@Param("projectId") String projectId,@Param("versionType") String versionType,@Param("isDel") int isDel);
}
